← Back to Projects

UPS—Summer Internship 2023

Role/OrganizationIT Intern | United Postal Service (UPS)
TagsCollaborationData AnalyticsESPInformation TechnologyPower BIProject ManagementService Management Center
Timeline6/2023 - 8/2023

Overview

As a returning UPS intern for PCWLA (Production Control Workload Automation) team, I found my experience greatly enriched. The insights I gathered during my previous internship empowered me to take on more leadership responsibilities and apply my knowledge more effectively this time around. I navigated the hybrid work setup seamlessly by working between the UPS Mahwah and Parsippany-Hills offices, 2-3 times a week.

Amidst this, I enthusiastically took on the 3 projects I was tasked with; these challenging projects pushed me to grow.

  • Project 1—WLA: Dashboard enhancement and validation
  • Project 2—PCWLA: Power Bi Change Control Forecasting
  • Project 3—CICS: Automating Certs

Project 1—WLA: Dashboard enhancement and validation

In collaboration with a WLA intern

Problem

  • 200-400K ESP jobs are processed each day
  • Daily audits are performed manually, which consume a lot of time
  • Due to contention, job failures do not open incidents

Goal

Validate Netcool incidents attached to job in ESP (SMPK or MVS1) by automation

Outcome

Created Power BI dashboard using data from Small Packages (SMPK) and MVS1, which was being validated by Netcool. The audits will be automated with data (from the mainframe) feeding directly into the dashboard after it is deployed into Power Automate and connected with SMC.

Below is the SMPK tab with the blank incidents visible.

Project 2—PCWLA: Power Bi Change Control Forecasting

Problem

PCWLA requests its customers to notify changes that require modification (changes) in the ESP environment, but the change tasks are known for this week and the next, but there are changes out there for weeks. Every change that’s on the mainframe goes to SMC

Goal

  • Future forecast for 4 weeks in advance using resources  ESP, ChangeMan and SMC to produce, track and monitor change controls.
  • The Forecast report is separated into 4 distinct:
    • Historical tracking—high-volume customers and the total changes made in the year
    • Change control types— the type of change our customers request
    • Change control tracking—the 4-week view
    • Workload tracking—workload being addressed by PCWLA
  • Allow PCWLA to be alerted ahead of time, so the change control is in the correct state for them to implement the requested workload modifications
  • Working with the data analytics team to build an effective dashboard forecasting and trending for changes to come.

Project 3—CICS: Automating Certs

In collaboration with a TEC intern

Problem

  • Tasked with development certs (CICS)
  • Digital certs consume a lot of time to create and information needs to be carefully inputted.
  • Collaborating with the CICS group

Goal

  • Formulate a plan to automate certs to save manual work

So far

  • requested for a windows jump server
    • goal is to push certs into a virtual environment for remote access rather than downloading locally
  • Learned the concept of AppviewX, Rest API, and digital certs
  • Meet with Info Sec for automation setup on AppViewx

New Skills

Takeaways

  • The EDA/TEC/ENT Intern and Leadership Mixer was impactful
  • Being in a corporate environment in- person helped me network and teamwork efficiently
  • Learning to have cohesive communication due to having various perspectives
  • A rewarding takeaway is having the flexibility to creatively ideate solutions and experimenting and run the project in my own way while learning

← Back to Projects